We were creating a extract at work from T-SQL and new that the we would need to export data with leading zeros. The data was not stored in the database with those leading zero values. The solution, create a simple … Continue reading T-SQL: Adding Leading Zeros with a Simple Scalar Function